www.gusucode.com > 帝国网站管理系统(帝国CMS) 6 > 帝国网站管理系统(帝国CMS) 6.5繁体UTF-8/upload/e/admin/ShopSys/ListPs.php
<?php define('EmpireCMSAdmin','1'); require("../../class/connect.php"); require("../../class/db_sql.php"); require("../../class/functions.php"); require "../".LoadLang("pub/fun.php"); $link=db_connect(); $empire=new mysqlquery(); $editor=1; //驗證用戶 $lur=is_login(); $logininid=$lur['userid']; $loginin=$lur['username']; $loginrnd=$lur['rnd']; $loginlevel=$lur['groupid']; $loginadminstyleid=$lur['adminstyleid']; //驗證權限 CheckLevel($logininid,$loginin,$classid,"shopps"); //增加配送方式 function AddPs($add,$userid,$username){ global $empire,$dbtbpre; if(empty($add[pname])) { printerror("EmptyPayname","history.go(-1)"); } //驗證權限 CheckLevel($userid,$username,$classid,"shopps"); $add[price]=(float)$add[price]; $sql=$empire->query("insert into {$dbtbpre}enewsshopps(pname,price,otherprice,psay) values('$add[pname]',$add[price],'$add[otherprice]','$add[psay]');"); $pid=$empire->lastid(); if($sql) { //操作日誌 insert_dolog("pid=".$pid."<br>pname=".$add[pname]); printerror("AddPayfsSuccess","AddPs.php?enews=AddPs"); } else { printerror("DbError","history.go(-1)"); } } //修改配送方式 function EditPs($add,$userid,$username){ global $empire,$dbtbpre; $add[pid]=(int)$add[pid]; if(empty($add[pname])||!$add[pid]) { printerror("EmptyPayname","history.go(-1)"); } //驗證權限 CheckLevel($userid,$username,$classid,"shopps"); $add[price]=(float)$add[price]; $sql=$empire->query("update {$dbtbpre}enewsshopps set pname='$add[pname]',price=$add[price],otherprice='$add[otherprice]',psay='$add[psay]' where pid='$add[pid]'"); if($sql) { //操作日誌 insert_dolog("pid=".$add[pid]."<br>pname=".$add[pname]); printerror("EditPayfsSuccess","ListPs.php"); } else { printerror("DbError","history.go(-1)"); } } //刪除配送方式 function DelPs($pid,$userid,$username){ global $empire,$dbtbpre; $pid=(int)$pid; if(!$pid) { printerror("EmptyPayfsid","history.go(-1)"); } //驗證權限 CheckLevel($userid,$username,$classid,"shopps"); $r=$empire->fetch1("select pname from {$dbtbpre}enewsshopps where pid='$pid'"); $sql=$empire->query("delete from {$dbtbpre}enewsshopps where pid='$pid'"); if($sql) { //操作日誌 insert_dolog("pid=".$pid."<br>pname=".$r[pname]); printerror("DelPayfsSuccess","ListPs.php"); } else { printerror("DbError","history.go(-1)"); } } $enews=$_POST['enews']; if(empty($enews)) {$enews=$_GET['enews'];} if($enews=="AddPs") { AddPs($_POST,$logininid,$loginin); } elseif($enews=="EditPs") { EditPs($_POST,$logininid,$loginin); } elseif($enews=="DelPs") { $pid=$_GET['pid']; DelPs($pid,$logininid,$loginin); } else {} $page=(int)$_GET['page']; $start=0; $line=16;//每頁顯示條數 $page_line=18;//每頁顯示鏈接數 $offset=$page*$line;//總偏移量 $query="select * from {$dbtbpre}enewsshopps"; $num=$empire->num($query);//取得總條數 $query=$query." order by pid limit $offset,$line"; $sql=$empire->query($query); $returnpage=page2($num,$line,$page_line,$start,$page,$search); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <link href="../adminstyle/<?=$loginadminstyleid?>/adminstyle.css" rel="stylesheet" type="text/css"> <title>管理配送方式</title> </head> <body> <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1"> <tr> <td width="50%" height="25">位置:<a href="ListPs.php">管理配送方式</a> </td> <td><div align="right"> <input type="button" name="Submit" value="增加配送方式" onclick="self.location.href='AddPs.php?enews=AddPs'"> </div></td> </tr> </table> <br> <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder"> <tr class="header"> <td width="8%" height="25"> <div align="center">ID</div></td> <td width="49%" height="25"> <div align="center">配送方式</div></td> <td width="22%"><div align="center">價格</div></td> <td width="21%" height="25"> <div align="center">操作</div></td> </tr> <? while($r=$empire->fetch($sql)) { ?> <tr bgcolor="#FFFFFF"> <td height="25"> <div align="center"> <?=$r[pid]?> </div></td> <td height="25"> <div align="center"> <?=$r[pname]?> </div></td> <td><div align="center"> <?=$r[price]?> 元 </div></td> <td height="25"> <div align="center">[<a href="AddPs.php?enews=EditPs&pid=<?=$r[pid]?>">修改</a>] [<a href="ListPs.php?enews=DelPs&pid=<?=$r[pid]?>" onclick="return confirm('確認要刪除?');">刪除</a>]</div></td> </tr> <? } ?> <tr bgcolor="#FFFFFF"> <td height="25" colspan="4"> <?=$returnpage?> </td> </tr> </table> </body> </html> <? db_close(); $empire=null; ?>